Release 10.1A: OpenEdge Development:
Programming Interfaces

Creating and maintaining sequences

You can create and maintain sequence definitions in a database using OpenEdge’s Data Dictionary. Progress stores all sequence values together in a single database block, and stores sequence names and their remaining attributes in a metaschema table named _Sequence.

For information on defining, editing, or deleting sequences in your database, see OpenEdge Development: Basic Development Tools (Character only) and, in graphical interfaces, the online Help for the OpenEdge Data Dictionary.

For information on using sequences in the 4GL, see the "Accessing and incrementing sequences" section.

Providing sequence security

You can restrict sequence access by assigning user privileges to the _Sequence metaschema table. The Can–Read privilege grants users permission to read the current value of a sequence with the CURRENT–VALUE function or to increment and read the next value of the sequence with the NEXT–VALUE function. The Can–Write privilege grants users permission to change the current value of a sequence with the CURRENT–VALUE statement. Any user privileges assigned to the _Sequence metaschema table apply to all sequences defined in the database.

For more information on providing security to a database table, see OpenEdge Data Management: Database Administration .

Dumping and loading sequences

You can dump and load sequence definitions and values using the Database Administration tool. Select the Database Administration item from the Tools menu of the ADE Desktop. For more information on dumping and loading sequences, see OpenEdge Data Management: Database Administration .